﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>FILESTREAM-WPF-HTTP Sample README</title>
</head>
<body>

	    <h2>
            Microsoft SQL Server Community Samples: End to End <i>(Brought to you by 
            Microsoft Developer &amp; Platform Evangelism)</i></h2>
    <h3>
        FILESTREAM-WPF-HTTP Sample README</h3>
<p>
        <b>Note:</b> This document is best viewed in a browser by Right clicking and selecting
        <i>View in Browser</i> from Visual Studio.</p>
    <p>
        <b>Sample Version:</b> 1.0</p>
    <p>
        <b>Date:</b> November 11, 2007</p>
    <p>
        <b>Authors:</b>
    </p>
    <ul>
        <li>Roger Doherty - <a href="http://blogs.msdn.com/rdoherty/">http://blogs.msdn.com/rdoherty/</a></li>
        <li>Zach Skyles Owens - <a href="http://blogs.msdn.com/zowens/">
            http://blogs.msdn.com/zowens/</a> </li>
    </ul>
    <p>
        <b>Description:</b> This sample application highlights using SQL Server 2008 
        varbinary(max) FILESTREAM.&nbsp; This is done by showing the following:</p>
    <ul>
        <li>Configuring database for FileStream and creating sample database and table</li>
        <li>Loading a file into the database</li>
        <li>Creating a service that sends the file to a client via HTTP</li>
        <li>Windows WPF client that uses the MediaElement tag to access the file from the 
            HTTP service</li>
    </ul>
<p>
        <b>Resources:</b></p>
<ul>
    <li><a href="http://www.codeplex.com/SQLSrvE2E">SQL Server Community Samples: End to 
        End on CodePlex</a></li>
    <li><a href="http://blogs.msdn.com/rdoherty/archive/2007/10/12/getting-traction-with-sql-server-2008-filestream.aspx">
        Working with FILESTREAM Overview</a></li>
    <li><a href="http://blogs.msdn.com/zowens/archive/2007/10/11/sql-server-2008-filestream-and-wpf-mediaelement.aspx">
        Sample FILESTREAM Architecture Overview</a></li>
</ul>
    <p>
                <b>System Requirements:</b><ul>
            <li>Windows Vista</li>
            <li>SQL Server 2008 CTP5 Default Local Instance</li>
            <li>Visual Studio 2008 Team Suite (Release Candidate build or greater)</li>
        </ul>
        	
	<p>
        <b>Deployment:</b></p>
    <ol>
        <li>Configure server, create database and tables by following scripts in
                        SQL Server Management Studio Solution located at:<br />
            <i>SAMPLE_ROOT_FOLDER/SQL Scripts/FilestreamWpfHttp/FilestreamWpfHttp.ssmssln<br />
            <br />
            </i></li>
        <li>Build <i>SqlFilestream</i> project<br />
            This will compile the class library needed by <i>FilestreamLoader</i> and <i>FilestreamHttpService</i>
            <ol>
                <li>Right click <i>SqlFilestream</i> in <i>Solution Explorer</i> </li>
                <li>Select <i>Build<br />
                    <br />
                    </i></li>
            </ol>
        </li>
        <li>Debug <i>FilestreamLoader</i> project
            <br />This will load the 25MB video located at:eo located at:<br />
            <i>SAMPLE_ROOT/Media/MSAllUpBI.wmv</i>
            <ol>
                <li>Right click <i>FilestreamLoader</i> in <i>Solution Explorer</i></li>
                <li>Select <i>Debug</i> -&gt; <i>Start New Instance<br />
                    <br />
                    </i></li>
            </ol>
        </li>
        <li>Debug the rest of the Solution
            <br />
            This will start the <i>FilestreamHttpService</i> project local server and run 
            the <i>FilestreamWindowsClient</i> application<ol>
                <li>Left click <i>Debug</i> in the toolbar </li>
                <li>Select <i>Start Debugging</i></li>
                <li>or just hit <i>F5</i></li>
            </ol>
        </li>
    </ol>
        	
	</body>
</html>
